/*
 * @Author: 蔡科 caikeps@163.com
 * @Date: 2024-03-16 13:54:29
 * @LastEditors: 蔡科 caikeps@163.com
 * @LastEditTime: 2024-03-16 14:38:12
 * @FilePath: /ai-center-server/src/db/sql.ts
 * @Description: 这是默认设置,请设置`customMade`, 打开koroFileHeader查看配置 进行设置: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
 */

export enum Sql {

    apps = `CREATE TABLE IF NOT EXISTS apps 
    (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name  VARCHAR(50)  NOT NULL,
        way INT,
        category_id INT,
        app_type INT,
        star INT,
        status INT,
        is_collect Boolean,
        groups VARCHAR(255),
        created_at INT,
        logo VARCHAR(255),
        desc VARCHAR(255)
    );`,

    category = `CREATE TABLE IF NOT EXISTS category_id 
    (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name VARCHAR(128) NOT NULL,
        way INT
    );`,


}